﻿CREATE TABLE [lov].[Entity] (
    [Id]          INT   NOT NULL IDENTITY,
    [Schema]      VARCHAR (100) CONSTRAINT [DF_Entity_Schema] DEFAULT ('dbo') NOT NULL,
    [Name]        VARCHAR (255) NOT NULL,
    [Description] VARCHAR (255) NULL,
    CONSTRAINT [PK_LOVGroup] PRIMARY KEY CLUSTERED ([Id] ASC) WITH (FILLFACTOR = 90)
);


GO
CREATE UNIQUE NONCLUSTERED INDEX [idx_Guard]
    ON [lov].[Entity]([Schema] ASC, [Name] ASC) WITH (IGNORE_DUP_KEY = ON);

